{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Polecenia","zadanie 1","zadanie 2","zadanie 3","zadanie 4","zadanie 5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Polecenia","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Nr grupy","Nazwisko","Imię","Nr albumu","Data","Nr zadania","Termin","Czas przygotowań [h]"]
[1,null,null,null,"2019-07-02",2,"pierwszy"]
[]
[null,{"$f":"IF(OR(A2=\"\",B2=\"\",C2=\"\",D2=\"\"),\"UZUPEŁNIJ SWOJE DANE!\",\"\")","v":"UZUPEŁNIJ SWOJE DANE!"}]
[]
[null,"Zasady kolokwium:"]
[null,"1. Zadania rozwiązywane SAMODZIELNIE - zabroniony jest kontakt z osobami w laboratorium jak i poza nim."]
[null,"2. Dozwolone materiały pomocnicze: notatki, książki."]
[null,"3. Wyniki należy umieszczać w żółtych polach obok wyszczególnionych statystyk!"]
[null,"4. Nie wolno zaokrąglać wyników!"]
[null,"5. Nie wolno zmieniać nazw istniejących arkuszy ani nazwy pliku."]
[null,"6. Plik należy przesłać do godziny 10:00 na adres Jacek.Szandula@ue.wroc.pl. W tytule maila podać (numer grupy) (przecinek) (spacja) (nazwisko) np.: 12, Kowalski"]
[]
[null,"Po kolokwium:"]
[null,"1. Ze strony szandulajacek.republika.pl należy pobrać plik z rozwiązanymi zadaniami."]
[null,"2. Aby sprawdzić poprawność rozwiązanych zadań należy:"]
[null,null,"a) otworzyć swój plik, przejść do arkusza zadanie 1, skopiować obszar odpowiedzi (czarna ramka), "]
[null,null,"b) otworzyć plik z rozwiązaniami, przejść do arkusza zadanie 1, zaznaczyć obszar odpowiedzi (czarna ramka),"]
[null,null,"c) wybrać polecenie WKLEJ SPECJALNIE, zaznaczyć opcję WARTOŚCI I FORMATY LICZB,"]
[null,null,"d) powtórzyć kroki a - c dla pozostałych zadań."]
[null,"3. Uzyskany wynik można odczytać w arkuszu Polecenia pliku z rozwiązaniami zadań."]
[]
[]
[]
[{"$f":"ADDRESS(ROW('zadanie 1'!H2),COLUMN('zadanie 1'!H2),4,1)","v":"H2"},{"$f":"ADDRESS(ROW('zadanie 1'!M13),COLUMN('zadanie 1'!M13),4,1)","v":"M13"}]
[{"$f":"ADDRESS(ROW('zadanie 2'!I2),COLUMN('zadanie 2'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 2'!N12),COLUMN('zadanie 2'!N12),4,1)","v":"N12"}]
[{"$f":"ADDRESS(ROW('zadanie 3'!H3),COLUMN('zadanie 3'!H3),4,1)","v":"H3"},{"$f":"ADDRESS(ROW('zadanie 3'!L14),COLUMN('zadanie 3'!L14),4,1)","v":"L14"}]
[{"$f":"ADDRESS(ROW('zadanie 4'!I2),COLUMN('zadanie 4'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 4'!M18),COLUMN('zadanie 4'!M18),4,1)","v":"M18"}]
[{"$f":"ADDRESS(ROW('zadanie 5'!I4),COLUMN('zadanie 5'!I4),4,1)","v":"I4"},{"$f":"ADDRESS(ROW('zadanie 5'!Q17),COLUMN('zadanie 5'!Q17),4,1)","v":"Q17"}]

{"sheet":"zadanie 1","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[10,8,10,10],[11,8,11,10],[12,8,12,10],[2,8,2,10],[3,8,3,10],[4,8,4,10],[7,8,7,10],[8,8,8,10],[9,8,9,10]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży określ składowe szeregu czasowego"]
[1,1488341.29,null,null,null,null,null,"a) Przeprowadź test współczynnika korelacji; α = 0,1"]
[2,1908544.67,null,null,null,null,null,null,"Współczynnik korelacji = "]
[3,2444697.92,null,null,null,null,null,null,"Statystyka testowa = "]
[4,2825532.27,null,null,null,null,null,null,"Wartość krytyczna  ="]
[5,2912553.46]
[6,3333433.45,null,null,null,null,null,"b) Składowe szeregu czasowego"]
[7,3985180.93,null,null,null,null,null,null,"Wahania przypadkowe"]
[8,3983573.6,null,null,null,null,null,null,"Stały poziom"]
[9,4038503.31,null,null,null,null,null,null,"Trend malejący"]
[10,4605501.6100000003,null,null,null,null,null,null,"Trend rosnący"]
[11,5077396.57,null,null,null,null,null,null,"Wahania sezonowe"]
[12,4949011.95,null,null,null,null,null,null,"Wahania cykliczne"]
[13,5081443.9800000004]
[14,5336118.46]
[15,5756600.2199999997]
[16,5759840.4000000004]
[17,5890529.3700000001]
[18,6177722.6100000003]
[19,6391474.3200000003]
[20,6421861.2999999998]
[21,6747247.7599999998]
[22,7043599.3700000001]
[23,6977433.96]
[24,7002173.0899999999]
[25,7179049.8899999997]
[26,7319296.0099999998]
[27,7578715.4100000001]
[28,7845916.8700000001]
[29,7862756.2999999998]
[30,7661936.9699999997]
[31,8115689.6200000001]
[32,8176532.0800000001]
[33,8379296.1200000001]
[34,8513356.2200000007]
[35,8604409.9700000007]
[36,8888196.75]
[37,8866686.2100000009]
[38,8986384.4700000007]
[39,9142100.8800000008]
[40,9456501.1899999995]
[41,9479827.7799999993]
[42,9464099.9800000004]
[43,9618344.5099999998]
[44,9920944.9600000009]
[45,9947813.1899999995]
[46,9949218.3699999992]
[47,9765276.2599999998]
[48,10130565.32]
[49,10349395.109999999]
[50,10510217.16]
[51,10318917.880000001]
[52,10487780.07]
[53,10438851.84]
[54,10845400.66]
[55,10908888.65]
[56,11048543.609999999]
[57,10940004.890000001]
[58,11259876.9]
[59,11368311.18]
[60,11434423.17]

{"sheet":"zadanie 2","index":2,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,12,8,13],[2,9,2,11],[3,9,3,11],[5,9,5,11],[6,9,6,11],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży w zł wyznacz:"]
[1,12086.43,null,null,null,null,null,null,"a) parametry modelu"]
[2,13783.79,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,15347.25,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,16985.740000000002,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[5,17052.939999999999,null,null,null,null,null,null,null,"Współczynnik determinacji ="]
[6,20362.240000000002,null,null,null,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[7,18390.72,null,null,null,null,null,null,"c) Uzupełnij poniższą tabelę"]
[8,22250.51,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Bezwzględny błąd prognozy ex ante","Względny błąd prognozy ex ante","Prognoza przedziałowa (p = 0,9)"]
[9,24790.3,null,null,null,null,null,null,null,null,null,null,"od","do"]
[10,23929.68,null,null,null,null,null,null,26]
[11,27447.279999999999,null,null,null,null,null,null,27]
[12,30391.09]
[13,28668.17]
[14,31968.85]
[15,31801.34]
[16,33109.46]
[17,37112.480000000003]
[18,36285.46]
[19,38363.589999999997]
[20,39305.25]
[21,42479.8]
[22,42266.54]
[23,43819.75]
[24,46113.69]
[25,50195.11]

{"sheet":"zadanie 3","index":3,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,8,3,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[10,8,11,8],[10,9,11,9],[10,10,11,10]]}
["Nr okresu","Sprzedaż w tys. zł",null,null,null,null,null,"Przy pomocy Solvera dokonaj optymalizacji modelu Holta przyjmując: F1 = y1, S1 = y2 – y1. "]
[1,64.099999999999994,null,null,null,null,null,"Optymalizację przeprowadź dla punktów startowych α = 0,5, β = 0,5."]
[2,65.3,null,null,null,null,null,"a) Wyznacz"]
[3,64.5,null,null,null,null,null,null,"α =",null,null,0.5]
[4,65.099999999999994,null,null,null,null,null,null,"β =",null,null,0.5]
[5,65.099999999999994,null,null,null,null,null,null,"s* ="]
[6,65.400000000000006,null,null,null,null,null,null,"Fn ="]
[7,66.400000000000006,null,null,null,null,null,null,"Sn ="]
[8,65.900000000000006]
[9,67.099999999999994,null,null,null,null,null,"b) Uzupełnij poniższą tabelę"]
[10,65.2,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Względny błąd prognozy"]
[11,67.7]
[12,66.900000000000006,null,null,null,null,null,null,50]
[13,66.3,null,null,null,null,null,null,51]
[14,68]
[15,67.599999999999994]
[16,65.900000000000006]
[17,66.599999999999994]
[18,67]
[19,64.8]
[20,65.599999999999994]
[21,63.9]
[22,64.099999999999994]
[23,62.3]
[24,61.7]
[25,63.3]
[26,62.2]
[27,63.3]
[28,61.3]
[29,61.6]
[30,61.4]
[31,59.7]
[32,59.2]
[33,59.8]
[34,59.8]
[35,58.4]
[36,57.8]
[37,57.3]
[38,55.1]
[39,55.2]
[40,54.9]
[41,53]
[42,52.4]
[43,51.2]
[44,50.2]
[45,48.8]
[46,47.3]
[47,46.1]
[48,44.2]
[49,43.2]

{"sheet":"zadanie 4","index":4,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[13,12,14,12],[2,9,2,11],[3,9,3,11],[4,9,4,11],[11,9,11,11],[13,10,14,10],[13,11,14,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie danych dziennych (od poniedziałku do piątku) o wartości sprzedaży w zł wyznacz:"]
[1,21929.67,null,null,null,null,null,null,"a) parametry modelu"]
[2,18293.37,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,17583.439999999999,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,18866.689999999999,null,null,null,null,null,null,null,"wskaźniki sezonowości"]
[5,16537.939999999999,null,null,null,null,null,null,null,null,null,"c1 ="]
[6,19983.169999999998,null,null,null,null,null,null,null,null,null,"c2 ="]
[7,15449.2,null,null,null,null,null,null,null,null,null,"c3 ="]
[8,15796.42,null,null,null,null,null,null,null,null,null,"c4 ="]
[9,17515.04,null,null,null,null,null,null,null,null,null,"c5 ="]
[10,14658.04,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[11,16758.68,null,null,null,null,null,null,null,"Względny poziom reszt ="]
[12,12692.91,null,null,null,null,null,null,"c) Prognozy na podane okresy"]
[13,13765.43,null,null,null,null,null,null,null,null,"Nr okresu","Prognoza wstępna","Prognoza ostateczna"]
[14,14589.58]
[15,12620.38,null,null,null,null,null,null,null,null,36]
[16,14998.93,null,null,null,null,null,null,null,null,37]
[17,10554.48,null,null,null,null,null,null,null,null,38]
[18,10217.41]
[19,12936.1]
[20,10290.66]
[21,12789.88]
[22,8142.83]
[23,8364.2900000000009]
[24,10175.86]
[25,7687.77]
[26,11101.52]
[27,6173.24]
[28,5708.68]
[29,8000.56]
[30,4942.9399999999996]
[31,8377.2900000000009]
[32,4108.67]
[33,3316.57]
[34,5210.4399999999996]
[35,2596.92]

{"sheet":"zadanie 5","index":5,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,14,15,14],[14,15,14,16],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[4,9,4,11],[5,9,5,11],[6,9,6,11],[7,9,7,11],[10,9,10,11],[11,9,11,11]]}
["Nr okresu","Y","X1","X2","X3",null,null,null,"Na podstawie wartości zmiennych Y, X1, X2 i X3 zbuduj model ekonometryczny wyjaśniający zmienną Y"]
[1,449.5,315.89999999999998,387.1,1.8879999999999999,null,null,null,"Poziom istotności dla oceny parametrów modelu przyjmij α = 0,05"]
[2,264.7,214.8,386.3,1.502,null,null,null,"Wyznacz"]
[3,381.4,285.7,389.6,1.734,null,null,null,"a) parametry modelu"]
[4,248.2,214.1,377,1.448,null,null,null,null," α0 ="]
[5,451.3,334.1,405.7,1.877,null,null,null,null," α1 ="]
[6,322.7,265.10000000000002,418,1.6970000000000001,null,null,null,null," α2 ="]
[7,365.9,294.10000000000002,329.6,1.599,null,null,null,null," α3 ="]
[8,417.3,327.7,352.9,1.837]
[9,420.6,333.9,371.1,1.6180000000000001,null,null,null,"b) Miary dopasowania modelu"]
[10,452.7,356.5,362.6,1.9450000000000001,null,null,null,null,"Współczynnik determinacji ="]
[11,438.7,352.8,395.8,1.843,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[12,475.8,378.2,308,1.8240000000000001]
[13,302,283.5,363.5,1.452,null,null,null,"c) Uzupełnij poniższą tabelę."]
[14,364.9,323.60000000000002,390.8,1.6339999999999999,null,null,null,"Nr okresu","Prognoza punktowa X1","Prognoza punktowa X2","Prognoza punktowa X3","Prognoza punktowa Y","Bezwzględny błąd prognozy ex ante dla Y","Względny błąd prognozy ex ante dla Y","Prognoza przedziałowa dla Y (p = 0,9)"]
[15,300.89999999999998,291.5,338.6,1.46,null,null,null,null,null,null,null,null,null,null,"od","do"]
[16,419.6,363.4,262.89999999999998,1.6220000000000001,null,null,null,42,463.96621951219498,231.3853658536585,1.1819402439024391]
[17,349.8,328,339.2,1.571]
[18,296.60000000000002,301.89999999999998,368.5,1.2150000000000001]
[19,515,430.7,271.5,1.6379999999999999]
[20,289,306.2,331.8,1.0780000000000001]
[21,323.10000000000002,330,304.10000000000002,1.2889999999999999]
[22,373.6,363,304.10000000000002,1.405]
[23,323.7,338.9,317.10000000000002,1.2490000000000001]
[24,435.1,406.7,311.39999999999998,1.454]
[25,278.7,321.89999999999998,344.7,1.109]
[26,419.1,406.2,184.9,1.5029999999999999]
[27,338.5,364.6,264.2,1.18]
[28,384.2,394.9,304.3,1.399]
[29,365.7,388.7,264.89999999999998,1.2929999999999999]
[30,439.6,435.1,277.10000000000002,1.419]
[31,380.5,405.7,299,1.2689999999999999]
[32,332.2,382.6,288.3,1.2709999999999999]
[33,448.3,453,301.2,1.4710000000000001]
[34,502,487.9,205.5,1.714]
[35,354.6,408.2,236.9,1.3340000000000001]
[36,359.7,415.4,340,1.1950000000000001]
[37,536.20000000000005,520.4,183.4,1.498]
[38,348.1,417.4,256,1.1910000000000001]
[39,226.3,352.3,302,0.76600000000000001]
[40,423,468.8,277,1.212]
[41,518.70000000000005,527.6,190.5,1.538]